# Aggregation example

In the following example, Mike the organization’s data scientist, wants to create an aggregation table that shows the total freight costs per shipping region and product category; for example, the total cost of shipping rice to Australia in 2015.

To achieve this objective, he adds the `CategoryName` and `ShipRegion` attributes to the Group By list and then adds the `Freight` attribute to the Aggregations list. As Mike is interested in the total freight cost, he selects SUM as the Aggregation Type.

![Example image displaying New Star Schema](https://help.qlik.com/en-US/compose/December2024/Content/Resources/Images/ComposeForDataWarehouses/agg_example.png)